<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  <html xmlns="http://www.w3.org/1999/xhtml">
		<head>
			<!-- template designed by Marco Von Ballmoos  -->
			<title>File Source for dbsession.php</title>
			<link rel="stylesheet" href="../media/stylesheet.css" />
											</head>
		<body>
						<h1>Source for file dbsession.php</h1>
<p>Documentation is available at <a href="../myLiveShop/_core_session_dbsession_php.html">dbsession.php</a></p>
<div class="src-code">
<pre><ol><li><a name="a1"></a><span class="src-php">&lt;?php</span></li>
<li><a name="a2"></a><span class="src-doc">/**</span></li>
<li><a name="a3"></a><span class="src-doc"> * Сессии в базе данных</span></li>
<li><a name="a4"></a><span class="src-doc"> * </span></li>
<li><a name="a5"></a><span class="src-doc"> * Класс для работы с сессиями хранимыми в базе данных</span></li>
<li><a name="a6"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@author</span><span class="src-doc"> Anton Zavidov</span></li>
<li><a name="a7"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@package</span><span class="src-doc"> myLiveShop</span></li>
<li><a name="a8"></a><span class="src-doc"> */</span></li>
<li><a name="a9"></a>&nbsp;</li>
<li><a name="a10"></a><a href="../myLiveShop/_core_functions_php.html#functionimport">import</a><span class="src-sym">(</span><span class="src-str">&quot;core.session&quot;</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a11"></a><span class="src-doc">/**</span></li>
<li><a name="a12"></a><span class="src-doc"> * Класс для работы с сессиями хранимыми в базе данных</span></li>
<li><a name="a13"></a><span class="src-doc"> *</span></li>
<li><a name="a14"></a><span class="src-doc"> */</span></li>
<li><a name="a15"></a><span class="src-key">class </span><a href="../myLiveShop/DBSession.html">DBSession</a> <span class="src-key">extends </span><a href="../myLiveShop/Session.html">Session</a><span class="src-sym">{</span></li>
<li><a name="a16"></a>    <span class="src-doc">/**</span></li>
<li><a name="a17"></a><span class="src-doc">     *Объект базы</span></li>
<li><a name="a18"></a><span class="src-doc">     *</span></li>
<li><a name="a19"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@var </span><span class="src-doc-type">db </span></li>
<li><a name="a20"></a><span class="src-doc">     */</span></li>
<li><a name="a21"></a>    <span class="src-key">private </span><a href="../myLiveShop/DBSession.html#var$base">$base</a>=<span class="src-id">null</span><span class="src-sym">;</span></li>
<li><a name="a22"></a>    <span class="src-doc">/**</span></li>
<li><a name="a23"></a><span class="src-doc">     * Id текущего пользователя</span></li>
<li><a name="a24"></a><span class="src-doc">     *</span></li>
<li><a name="a25"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@var </span><span class="src-doc-type">int </span></li>
<li><a name="a26"></a><span class="src-doc">     */</span></li>
<li><a name="a27"></a>    <span class="src-key">public </span><a href="../myLiveShop/DBSession.html#var$current_user">$current_user</a>=<span class="src-num">0</span><span class="src-sym">;</span></li>
<li><a name="a28"></a>    <span class="src-doc">/**</span></li>
<li><a name="a29"></a><span class="src-doc">     * Хеш сессии</span></li>
<li><a name="a30"></a><span class="src-doc">     *</span></li>
<li><a name="a31"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@var </span><span class="src-doc-type">string </span></li>
<li><a name="a32"></a><span class="src-doc">     */</span></li>
<li><a name="a33"></a>    <span class="src-key">private </span><a href="../myLiveShop/DBSession.html#var$hash">$hash</a>=<span class="src-id">null</span><span class="src-sym">;</span></li>
<li><a name="a34"></a>    <span class="src-doc">/**</span></li>
<li><a name="a35"></a><span class="src-doc">     * Открываем сессию</span></li>
<li><a name="a36"></a><span class="src-doc">     *</span></li>
<li><a name="a37"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$save_path </span></li>
<li><a name="a38"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$session_name </span></li>
<li><a name="a39"></a><span class="src-doc">     */</span></li>
<li><a name="a40"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../myLiveShop/DBSession.html#methodopen">open</a><span class="src-sym">(</span><span class="src-var">$save_path</span>=<span class="src-id">null</span><span class="src-sym">, </span><span class="src-var">$session_name</span>=<span class="src-id">null</span><span class="src-sym">)</span><span class="src-sym">{</span></li>
<li><a name="a41"></a>        <span class="src-key">if</span><span class="src-sym">(</span><span class="src-sym">!</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../myLiveShop/DBSession.html#var$base">base</a><span class="src-sym">)</span><span class="src-sym">{    </span></li>
<li><a name="a42"></a>            <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../myLiveShop/DBSession.html#var$base">base</a>=<span class="src-id"><a href="../myLiveShop/Core.html">Core</a></span><span class="src-sym">::</span><a href="../myLiveShop/Core.html#methodgetDB">getDB</a><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a43"></a>        <span class="src-sym">}</span></li>
<li><a name="a44"></a>        <span class="src-comm">//записыываем id сесии в переменную mysql</span></li>
<li><a name="a45"></a>        <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../myLiveShop/DBSession.html#var$base">base</a><span class="src-sym">-&gt;</span><span class="src-id">query</span><span class="src-sym">(</span><span class="src-str">'SET @current_session='</span>.<span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../myLiveShop/DBSession.html#var$base">base</a><span class="src-sym">-&gt;</span><span class="src-id">eraseData</span><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../myLiveShop/Session.html#methodgetId">getId</a><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">,</span><span class="src-id"><a href="../myLiveShop/DB.html">DB</a></span><span class="src-sym">::</span><span class="src-id">TYPE_STRING</span><span class="src-sym">))</span><span class="src-sym">;</span></li>
<li><a name="a46"></a>        <span class="src-key">if</span><span class="src-sym">(</span><a href="../myLiveShop/_core_functions_php.html#functioncheckLogConfig">checkLogConfig</a><span class="src-sym">(</span><span class="src-str">&quot;debug&quot;</span><span class="src-sym">))</span><span class="src-key">new </span><span class="src-id"><a href="../myLiveShop/Log.html">Log</a></span><span class="src-sym">(</span><span class="src-str">&quot;Запущенна сессия &quot;</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a47"></a>        <span class="src-comm">//$_SESSION=array();</span></li>
<li><a name="a48"></a>        <span class="src-key">return </span><span class="src-id">true</span><span class="src-sym">;</span></li>
<li><a name="a49"></a>    <span class="src-sym">}</span></li>
<li><a name="a50"></a>    <span class="src-doc">/**</span></li>
<li><a name="a51"></a><span class="src-doc">     * Закрываем сессию</span></li>
<li><a name="a52"></a><span class="src-doc">     *</span></li>
<li><a name="a53"></a><span class="src-doc">     */</span></li>
<li><a name="a54"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../myLiveShop/DBSession.html#methodclose">close</a><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">{</span></li>
<li><a name="a55"></a>        <span class="src-comm">//$this-&gt;base-&gt;delete(Config::_(&quot;session_table&quot;),'`key`=&quot;'.$this-&gt;getId().'&quot;');</span></li>
<li><a name="a56"></a>        <span class="src-key">if</span><span class="src-sym">(</span><a href="../myLiveShop/_core_functions_php.html#functioncheckLogConfig">checkLogConfig</a><span class="src-sym">(</span><span class="src-str">&quot;debug&quot;</span><span class="src-sym">))</span><span class="src-key">new </span><span class="src-id"><a href="../myLiveShop/Log.html">Log</a></span><span class="src-sym">(</span><span class="src-str">&quot;Cесcия закрыта&quot;</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a57"></a>        <span class="src-key">return </span><span class="src-id">true</span><span class="src-sym">;</span></li>
<li><a name="a58"></a>    <span class="src-sym">}</span></li>
<li><a name="a59"></a>    <span class="src-doc">/**</span></li>
<li><a name="a60"></a><span class="src-doc">     * Читаем данные</span></li>
<li><a name="a61"></a><span class="src-doc">     *</span></li>
<li><a name="a62"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$id </span><span class="src-doc">имя переменной</span></li>
<li><a name="a63"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">mixed </span></li>
<li><a name="a64"></a><span class="src-doc">     */</span></li>
<li><a name="a65"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../myLiveShop/DBSession.html#methodread">read</a><span class="src-sym">(</span><span class="src-var">$id</span><span class="src-sym">)</span><span class="src-sym">{</span></li>
<li><a name="a66"></a>        <span class="src-comm">//обрабатываем имя переменной</span></li>
<li><a name="a67"></a>        <span class="src-var">$result</span>=<span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../myLiveShop/DBSession.html#var$base">base</a><span class="src-sym">-&gt;</span><span class="src-id">getArray</span><span class="src-sym">(</span><span class="src-str">'SELECT `value`,`hash` FROM '</span>.<span class="src-id"><a href="../myLiveShop/Config.html">Config</a></span><span class="src-sym">::</span><a href="../myLiveShop/Config.html#method_">_</a><span class="src-sym">(</span><span class="src-str">&quot;session_table&quot;</span><span class="src-sym">)</span>.<span class="src-str">' WHERE `key`='</span>.<span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../myLiveShop/DBSession.html#var$base">base</a><span class="src-sym">-&gt;</span><span class="src-id">eraseData</span><span class="src-sym">(</span><span class="src-var">$id</span><span class="src-sym">,</span><span class="src-id"><a href="../myLiveShop/DB.html">DB</a></span><span class="src-sym">::</span><span class="src-id">TYPE_STRING</span><span class="src-sym">)</span>.<span class="src-str">' LIMIT 1'</span><span class="src-sym">,</span><span class="src-id">true</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a68"></a>        <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../myLiveShop/DBSession.html#var$hash">hash</a>=<span class="src-var">$result</span><span class="src-sym">[</span><span class="src-str">'hash'</span><span class="src-sym">]</span><span class="src-sym">;</span></li>
<li><a name="a69"></a>        <span class="src-key">return </span><a href="http://www.php.net/stripslashes">stripslashes</a><span class="src-sym">(</span><span class="src-var">$result</span><span class="src-sym">[</span><span class="src-str">'value'</span><span class="src-sym">]</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a70"></a>    <span class="src-sym">}</span></li>
<li><a name="a71"></a>    <span class="src-doc">/**</span></li>
<li><a name="a72"></a><span class="src-doc">     * Записываем данные</span></li>
<li><a name="a73"></a><span class="src-doc">     *</span></li>
<li><a name="a74"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$id </span><span class="src-doc">имя переменной</span></li>
<li><a name="a75"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$sess_data </span><span class="src-doc">данные</span></li>
<li><a name="a76"></a><span class="src-doc">     */</span></li>
<li><a name="a77"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../myLiveShop/DBSession.html#methodwrite">write</a><span class="src-sym">(</span><span class="src-var">$id</span><span class="src-sym">, </span><span class="src-var">$sess_data</span><span class="src-sym">)</span><span class="src-sym">{</span></li>
<li><a name="a78"></a>        <span class="src-var">$hash</span>=<a href="http://www.php.net/md5">md5</a><span class="src-sym">(</span><span class="src-var">$sess_data</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a79"></a>        <span class="src-key">if</span><span class="src-sym">(</span><span class="src-var">$hash</span>==<span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../myLiveShop/DBSession.html#var$hash">hash</a><span class="src-sym">)</span><span class="src-sym">{</span></li>
<li><a name="a80"></a>            <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../myLiveShop/DBSession.html#var$base">base</a><span class="src-sym">-&gt;</span><span class="src-id">update</span><span class="src-sym">(</span><span class="src-id"><a href="../myLiveShop/Config.html">Config</a></span><span class="src-sym">::</span><a href="../myLiveShop/Config.html#method_">_</a><span class="src-sym">(</span><span class="src-str">&quot;session_table&quot;</span><span class="src-sym">)</span><span class="src-sym">,</span><span class="src-key">array</span><span class="src-sym">(</span><span class="src-str">'modification'</span>=&gt;<a href="http://www.php.net/gmdate">gmdate</a><span class="src-sym">(</span><span class="src-str">&quot;Y-m-d H:i:s&quot;</span><span class="src-sym">))</span><span class="src-sym">,</span><span class="src-str">&quot;`key`='&quot;</span>.<span class="src-var">$id</span>.<span class="src-str">&quot;' LIMIT 1&quot;</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a81"></a>            <span class="src-key">return</span><span class="src-sym">;</span></li>
<li><a name="a82"></a>        <span class="src-sym">}</span></li>
<li><a name="a83"></a>        <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../myLiveShop/DBSession.html#var$base">base</a><span class="src-sym">-&gt;</span><span class="src-id">eraseData</span><span class="src-sym">(</span><span class="src-var">$sess_data</span><span class="src-sym">,</span><span class="src-id"><a href="../myLiveShop/DB.html">DB</a></span><span class="src-sym">::</span><span class="src-id">TYPE_STRING</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a84"></a>        <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../myLiveShop/DBSession.html#var$base">base</a><span class="src-sym">-&gt;</span><span class="src-id">eraseData</span><span class="src-sym">(</span><span class="src-var">$id</span><span class="src-sym">,</span><span class="src-id"><a href="../myLiveShop/DB.html">DB</a></span><span class="src-sym">::</span><span class="src-id">TYPE_STRING</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a85"></a>        <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../myLiveShop/DBSession.html#var$base">base</a><span class="src-sym">-&gt;</span><span class="src-id">query</span><span class="src-sym">(</span><span class="src-str">&quot;INSERT INTO `&quot;</span>.<span class="src-id"><a href="../myLiveShop/Config.html">Config</a></span><span class="src-sym">::</span><a href="../myLiveShop/Config.html#method_">_</a><span class="src-sym">(</span><span class="src-str">&quot;session_table&quot;</span><span class="src-sym">)</span>.<span class="src-str">&quot;` </span></li>
<li><a name="a86"></a><span class="src-str">        (`key`,`value`,`modification`,`user_id`,`hash`) </span></li>
<li><a name="a87"></a><span class="src-str">        VALUES (&quot;</span>.<span class="src-var">$id</span>.<span class="src-str">&quot;,&quot;</span>.<span class="src-var">$sess_data</span>.<span class="src-str">&quot;,'&quot;</span>.<a href="http://www.php.net/gmdate">gmdate</a><span class="src-sym">(</span><span class="src-str">&quot;Y-m-d H:i:s&quot;</span><span class="src-sym">)</span>.<span class="src-str">&quot;',&quot;</span>.<span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../myLiveShop/DBSession.html#var$current_user">current_user</a>.<span class="src-str">&quot;, '&quot;</span>.<span class="src-var">$hash</span>.<span class="src-str">&quot;') </span></li>
<li><a name="a88"></a><span class="src-str">        ON DUPLICATE KEY UPDATE `value`=&quot;</span>.<span class="src-var">$sess_data</span>.<span class="src-str">&quot;, `modification`='&quot;</span>.<a href="http://www.php.net/gmdate">gmdate</a><span class="src-sym">(</span><span class="src-str">&quot;Y-m-d H:i:s&quot;</span><span class="src-sym">)</span>.<span class="src-str">&quot;', `hash`='&quot;</span>.<span class="src-var">$hash</span>.<span class="src-str">&quot;'&quot;</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a89"></a>    <span class="src-sym">}</span></li>
<li><a name="a90"></a>    <span class="src-doc">/**</span></li>
<li><a name="a91"></a><span class="src-doc">     * Удаляем данные</span></li>
<li><a name="a92"></a><span class="src-doc">     *</span></li>
<li><a name="a93"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$id </span><span class="src-doc">имя переменной</span></li>
<li><a name="a94"></a><span class="src-doc">     */</span></li>
<li><a name="a95"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../myLiveShop/DBSession.html#methoddestroy">destroy</a><span class="src-sym">(</span><span class="src-var">$id</span><span class="src-sym">)</span><span class="src-sym">{</span></li>
<li><a name="a96"></a>        <span class="src-comm">//обрабатываем имя переменной</span></li>
<li><a name="a97"></a>        <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../myLiveShop/DBSession.html#var$base">base</a><span class="src-sym">-&gt;</span><span class="src-id">eraseData</span><span class="src-sym">(</span><span class="src-var">$id</span><span class="src-sym">,</span><span class="src-id"><a href="../myLiveShop/DB.html">DB</a></span><span class="src-sym">::</span><span class="src-id">TYPE_STRING</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a98"></a>        <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../myLiveShop/DBSession.html#var$base">base</a><span class="src-sym">-&gt;</span><span class="src-id">delete</span><span class="src-sym">(</span><span class="src-id"><a href="../myLiveShop/Config.html">Config</a></span><span class="src-sym">::</span><a href="../myLiveShop/Config.html#method_">_</a><span class="src-sym">(</span><span class="src-str">&quot;session_table&quot;</span><span class="src-sym">)</span><span class="src-sym">,</span><span class="src-str">'`key`=&quot;'</span>.<span class="src-var">$id</span>.<span class="src-str">'&quot;'</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a99"></a>        <span class="src-key">return </span><span class="src-id">true</span><span class="src-sym">;</span></li>
<li><a name="a100"></a>    <span class="src-sym">}</span></li>
<li><a name="a101"></a>    <span class="src-doc">/**</span></li>
<li><a name="a102"></a><span class="src-doc">     * Очищаем просроченные сессии</span></li>
<li><a name="a103"></a><span class="src-doc">     *</span></li>
<li><a name="a104"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">int </span><span class="src-doc-var">$maxlifetime </span><span class="src-doc">время жизни сессии</span></li>
<li><a name="a105"></a><span class="src-doc">     */</span></li>
<li><a name="a106"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../myLiveShop/DBSession.html#methodgc">gc</a><span class="src-sym">(</span><span class="src-var">$maxlifetime</span><span class="src-sym">)</span><span class="src-sym">{</span></li>
<li><a name="a107"></a>        <span class="src-key">if</span><span class="src-sym">(</span><a href="../myLiveShop/_core_functions_php.html#functioncheckLogConfig">checkLogConfig</a><span class="src-sym">(</span><span class="src-str">&quot;debug&quot;</span><span class="src-sym">))</span><span class="src-key">new </span><span class="src-id"><a href="../myLiveShop/Log.html">Log</a></span><span class="src-sym">(</span><span class="src-str">&quot;Запущен чистильщик сессий &quot;</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a108"></a>        <span class="src-key">return </span><span class="src-id">true</span><span class="src-sym">;</span></li>
<li><a name="a109"></a>    <span class="src-sym">}</span></li>
<li><a name="a110"></a><span class="src-sym">}</span></li>
</ol></pre>
</div>
	<p class="notes" id="credit">
		Документ создан Mon, 14 Feb 2011 01:08:40 +0200 в <a href="http://www.phpdoc.org" target="_blank">phpDocumentor 1.3.0RC3</a>
	</p>
	</body>
</html>